After creating sheets and arrange them on different folders under Sheet Index the Sequence number is set to count all sheets in all folders.
Please add the property of the Sequence number that count only inside the folder and restart to 1 on the next folder - screenshot attached for the required values.
Thanks for filing this idea. The required action is possible already see screenshot attached. Does this cover your needs if not what is missing?