Opera is switching tabs by "most recently used" order, just like Windows does for applications with Alt+Tab. That's exactly what I want, but if it confuses you, you can turn it off in the settings ("[x] Cycle tabs in most recently used order")