A grandmother who is terminally ill has been granted her life’s wish of being taken on the back of a Harley-Davidson motorcycle