https://sqlrelease.com/generate-serial-number-for-each-consecutive-set-of-numbers
Generate serial number for each consecutive set of numbers