In the version of Mail in 10.5 and below, I could only arrange the mailboxes in the On My Mac section of the sidebar by using a spaces in front of the mailbox names to control their position.
This is no longer required in Snow Leopard -- mailboxes, including those in subfolders, can now be dragged exactly where you'd like them to appear.

