The historic church, where the late Queen once worshipped, attracted multiple bids well above the £160,000 price tag.