I'm sure you remembered bubble sort from school.

suppose your field names: aa,bb,cc
your new field : dd
you want to insert dd after bb

alter table mytab add column dd c(10)
alter table mytab add temp i
use mytab
repl temp with cc all
use
alter table mytab drop column cc
alter table mytab add column cc
use mytab
repl cc with temp all
use
alter table mytab drop column temp

I just write that. I didn't try. Maybe some syntax mistakes.
-------------------------
this the basic. You need them for automation that:
-for/next
-fcount()
-field()
-and use bubble sort :)