Lando Norris believes he will need "some magic" to beat his McLaren team-mate and title rival Oscar Piastri in Sunday's Dutch Grand Prix after narrowly losing the pair's battle for pole position in qualifying.