Drinking alcohol most days of the week can significantly protect against developing diabetes, a study has found.