Diego Maradona ‘died in agony’ as horrifying details of football legend’s death emerge