This find is positive for the UK/Scotland/Shetland. But it isn't big enough to pay for Scottish independence. It's very expensive to extract oil from the North Sea. So the price per barrel has to be quite high in order for the project to become financially viable. IT's also worth remembering that fields are plugged when the product stops making money, and not when the field is actually empty.
In last Scottish Independence referendum the finances of Scottish independence did not account for the enormous cost of decommissioning the many offshore platforms in Scottish waters. A huge oversight. And then the price of oil dropped, huge swathes of the British workforce have been laid off, and several oil services and construction companies have gone under. Oil will come back, but not for some time. And not until it does, can the operators afford to undertake any but the most essential projects.
So, it's good news that there's a find. But, I think it will be some time before the project gets funding/sanction.
Yes, I have worked in the oil industry. (But, before you start throwing tomoatoes, I'd like to point out that at least I am not a banker :-))