Ditching famous venues such as the O2 Arena or Wembley Stadium, the actor, 56, performed for a much smaller crowd at Scarborough's Open Air Theatre