I'm not in favor of changing the order of columns, but it is possible.

It is very easy to change the order of the columns in SSMS if you go into the table design view and just select a column and move it up or down with the mouse.

I can think of one scenario where you might want to change the order of the columns - one best practice that I've seen is to have columns for the record creation date & user as the last two columns. If you need to add a new column to the table, it would be nice to keep those two columns at the end.