People who walked, ran, swam and cycled in memory of former Scottish rugby international Doddie Weir have raised more than £1 million for motor neurone disease (MND) research, a charity has announced.