Former British PM believes Northern Ireland will leave UK in the long term – but remains opposed to Scottish independence