Start Auto Sequence Item with Already Opened Item Sequence

We're looking for some guidance on our item code generation process. We're currently creating new item code rules based on a combination of our "Major Category Code" and "Minor Category Code."

Our current item code structure looks something like this:[PREFIX] - [Major Category]-[Minor Category]-[Sequence Number].

For instance, you might see codes like:

7251-001-0001-0001

7251-001-0001-0002

7251-001-0002-0001

The challenge we're facing is that the sequence number (the last part, e.g., -0001, -0002) restarts from '1' for each new unique combination of Major and Minor Category.

Our main question is: When we define these new item code rules in the system, how do we tell the system what the starting sequence number should be for each specific Major/Minor Category combination?