The majority of adults in England are drinking within the recommended weekly guidelines, but alcohol-related deaths are rising, latest official figures show.