The 54-year-old was 'completely sober' when he ploughed into more than 100 men, women and children on Water Street