With another stored query I've used Folder Options / Display / Ignore Prefix, but I can't see an opportunity here to sort based on suffix i.e. numbers at the end of a filename.
Assuming the prefix isn't the same (or just a few common strings) for each file, you would need to make a script column that extracts the suffix you want to sort on from each file, then sort by that.
(Nothing really specific to stored queries here. It'd work the same in any folder.)
There are some regex column scripts on the forum which could probably do it for you without having to write any code. Some have UIs for setting up the columns and regex.