I think is just a good idea to see a history of building a post, but it is terrible to how pushes the post id.
Why you didn't build a new table like $prefix_posts_revision and linking it with the published post?
I know about many blogger, that they are very fussy with the post id.
I think the right way to build a post is over 3 tables ->
Writing a post in $prefix_posts_temp
Publish the post
... revisions move to $prefix_posts_revision
... publish version to $prefix_posts
many greeting from germany