Eran Zahavi scores record-breaking 33rd goal for national team, but late winner by Scotland against Faroe Islands means Qatar dream almost over