But then you would have had 64 bit ID by default anyway.
Why can't you just redirect the writes to a new temporary table and join the original and temporary on reads? (I'm not a database admin)
I'm actually interested in this answer as well. I know of a company using a proprietary db and now that their growth has literally exploded, they're stuck with it.
I wonder what literally exploding growth looks like...