Alter table query

Question

How do I arrange the column i create to be in a certain order

at the moment I have query to add a column but the column im adding , i want to put before a certain column, example below'

ALTER TABLE Table1 ADD col D Text

example:

col A,  col  B , col C, col D

I want to put col D before  col B

Output Below:

col A, col D, col B , col C