ADD column with column definition before or after one specific column

ALTER TABLE actor 
ADD COLUMN create_date datetime NOT NULL DEFAULT '2020-10-01 00:00:00'
AFTER last_update