Taking part in a Scottish paddleboard marathon, Simon Usborne reflects on the sport’s unlikely evolution