Brexit is a “shared nightmare” which could be “terminal” for large parts of Scotland’s third sector, it has been claimed