Actually I would use a script that clears all of my modules and then resets the counter as well. With this script I can modify where the count should start at. For example, I would like for the incidents to start from 100000000 and the Changes from 20000000. You can do all this by using this script below:
Make sure you take a backup of the database prior applying the script.
Sorry for the late reply Motaz.
Thank you, i will test this on DEV and see how it goes.