Is there a way to specify where the new column will be placed or ordered?

Answer 1

yes, you can use after to place the new column as

alter table tablename add name varchar (100) after id