Greeks, Romans, Norse and Celts all rooted their fertility myths in the apple – and through its association with the Garden of Eden it came to symbolise irresistible temptation