OK, little bit of experimentation has found the following:
If I close the Opera browser and relaunch it in the same session of using the computer, there is no issue and if I close the Opera browser and shut the computer down, restart and launch Opera, there is no issue. Hurrah!
However, if I close the Opera browser and put the computer into sleep mode, then wake the computer an error message is displayed in the bottom right of the screen, with the vague message of:
"An error has occurred. The VPN has been disconnected", together with two buttons - a 'learn more' and 'cancel' button.
The 'Learn more' simply links to the general help screen, and without any specific error details to refer to isn't much help and, as expected, 'cancel' just closes the error message window.
I then open Opera to connect to the VPN but at that point it is opening with the retained tabs.
So the issue appears to be linked to putting the computer into Sleep mode and re-waking it - it seems like Opera VPN Pro doesn't like being woken up!