Repeated lockdowns which forced Scots to stay at home have been blamed for a large rise in problem drinking in recent years.