Hello Rachana Pandey,
The use case will be effective if you do it manually using microflow/nanoflow.
Because the most suggested way of using auto number with achieve the use case automatically but if you cancel the changes the number generated won’t be canceled so it will result in missing number.
Hope my answer helps. Reach me out for any queries.