straight forward method is to use below INSERT INTO new ( c2, c3, c1 ) SELECT (columns in the expected order) from old;

This worked like magic for me.