McGregor enjoyed a three-day bender in the city almost a decade ago when he attended the Grand National and was rumoured to have visited Pimblett's house