Certainly it will diminish the international standing of England.  There are risks for both countries.  Emotionally, the shock would be profound.  For Northern Ireland, a UK shorn of Scotland would hardly make continued adherence to the union more attractive.  It is suggested that Scotland generates 10% of UK income with 7% of the population.