If you use SSMS (the SQL gui) to change the table, you can add the column wherever you want. SSMS will generate a script to recreate the table with the columns in the order you want. WARNING: if the table is small, this will work fine. For a large table, it might time out or take a very long time.
If the table is (very) large, the only other way would be to create a new table with the new columns in the order you want, then copy the existing table into the new table (then finally drop the old table).