Make alt-tab sequential, not 'sticky'
This isn't a complete solution, but it may get you closer to your goal: this extension makes the app switcher choose only from the subset of apps on the current workspace. So you may be able to get a similar list of apps, and re-arrange them in the order you want.
https://extensions.gnome.org/extension/4145/workspace-isolated-app-switcher/