Go to the main Settings app on your phone, look perhaps in the Display section for an option called "Auto-rotate screen" or similar and enable it. You may also find this option exploring the quick settings toggles in the notifications area.
Then it'll work as expected.
It might be disabled, because weirdly it seems Opera auto-rotates videos regardless of this setting.