Lord Wormald’s payout equates to around £2,000 for each day in his role as cabinet secretary