Find Sequences of any ranges

Question

I need to find number sequence ranges in below number list. there are diffent number serials in the list

https://docs.google.com/spreadsheets/d/1ocZtUeaKuvq9WMMP-QKbvhsQzZJ7SqYDOLH9acoBVa0/edit?usp=sharing

pls assist to find a foumular or rangers

sample

Start Number - End number

9402970201041150 - 9402970201041239

tks isuru

Answer 1

see:

=INDEX("9402970"&SEQUENCE(C2-C1, 1, 
 REGEXEXTRACT(TEXT(C1, "0")&"", "\d{9}$")*1))