> Is there any smart SQL that would perform this renumbering?

Solved this problem by avoiding the need for renumbering in the first
place :)

// David