How to add a column to DB with weight by using hook_update_N?
db_add_field doesn't support AFTER, which you would need to create your desired query. 

You'll need to build an appropriate SQL string and run it through db_query() instead.