Add a column at a specific position in system versioned temporal table
Once you have fully turned versioning off for that table, the base table and the history table are just two normal tables. So you can:

Turn of history
Add the column into the base table in the place you want (you'll need to use the &quot;new table, copy data, drop old, rename new&quot; approach as you can't add columns in a particular place otherwise)
Repeat this column add for the history table
Recreate the versioning relationship between the two tables

But I would recommend avoiding the extra complication and just adding the new column to the end unless this is causing you a problem beyond aesthetics.