The “warning lights are flashing” for the NHS, the Scottish Government has been warned, as figures revealed thousands are continuing to wait more than eight hours in A&E.