There's no option to adjust it. Closing the last tab of the only remaining window will just create a new start page tab. This is intentional as that's how most Opera users want it.
If you have multiple Opera windows open, closing the last tab in a window will also close that window though.