Hungary and Ireland faced off in a crucial World Cup qualifier, with the visitors securing a thrilling equaliser for a dramatic finish.