Calibre can also automatically add the series and order to the title when transferring. Use the plugboard feature.
https://manual.calibre-ebook.com/template_lang.html
This is what I have set in my Metadata Plugboard:
Code:
{series:|| }{series_index:0>2s|[|] }{title}