Health campaigners warned Scotland is "firmly in the grip of an alcohol health emergency"