TO change the order of fields:
ALTER TABLE table_name MODIFY COLUMN field_name definition AFTER other_field_name
definition = the type of field it is
Such as VARCHAR or INT
example:
ALTER TABLE Games_Mechanic MODIFY COLUMN Mechanic_ID int AFTER Game_ID
