A standing ovation greeted former Carlisle United man Joe Thompson as the inspirational footballer stepped forward to receive a special award.