>I guess I have to do SCAN ... ENDSCAN and REPLACE to make it permanent?

My first question is why? You can temporarily set the order of a table to any index, so there is not much point is changing the physical order.