Drinking less than one can of sugary drink or 100% fruit juice per day is linked to an increased risk of cancer, a study suggests.