You're in a relational database - column order shouldn't matter.

But in order to do it, you need to recreate the table and populate it, as ovinson posted.

Careful with sp_rename, though...