The amount of alcohol per adult bought in Scotland last year fell to its lowest level since records began.