2 answers
Nope. Not with the Workflows as of now[ Why didn't the Flow Triggers go GA :-(]. But you could think about creating a Custom Button that runs some JavaScript to see what the last number was and then opens the new Opportunity with the number auto-filled with a URL Hack.
And Apex Triggers - that's the ideal way to go( if you/ve resources )!