Making such a modification to the database is a not a supported scenario and will most likely cause a problem, even if it is not one that is immediately apparent.
What I would suggest instead is to use the IDataEvent
and some custom logic that checks whether the ID should be set to the next in order. If so finds the currently last one and sets it to next one.
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal
and vote to affect the priority of the items