SSDT table column order
You are correct, the only way to "rearrange" the order of the columns is to create a table with the new structure and push the old data into it, drop the old table and then rename the new table (or some variation of that).  It requires copying all the data in the table and some drops and renames.