Certainly not, as currently constituted. If there were a common fisheries policy that actually protected Scotland’s fishing industry, instead of it being used by successive UK Governments as an excuse to sell it out, that might be a different matter.
There has of course been a public vote on the possibility of one of the consequences of a hard Brexit: a hard border across the island of Ireland.