Looks like this fixes this issue:
Opera Menu > Settings > Basic > On Startup > uncheck "Display the start page first"
After making this settings change, when starting Opera, it will not open a new tab and will display last tab you were viewing before you closed it the last time.