It's not possible in direct way!
Indirect way is:
1) Create new table with the same collection of columns plus new one (at specific position),
2) Copy data into new table fro existing table,
3) Remove old table (existing one),
4) Rename new table
Please, use SearchBox (at the top-right corner of this site). This question was asked several times...
how to add column at specific position in sql server[
^]
how to add column at a specific position in sql server 2005[
^]