In Scotland, there is more supermarket floorspace per head than anywhere else in the UK. It’s no surprise then that Scottish indies are feeling the heat, but some are triumphing. Peter Cripps heads north to discover David Sands’ blueprint for the c-store of tomorrow