Option (D) is correct.
Explanation: Sodium reacts with oxygen far more vigorously than magnesium does, so the burning test shows that sodium is more reactive than magnesium. But zinc, iron, copper and lead all behave in much the same way in the flame: none of them burns. An experiment in which four metals give the same result cannot put those four in order. This is exactly the limitation the book points out after Activity 3.9: burning in oxygen does not help us decide the reactivity of zinc, iron, copper or lead. Their order is settled by other evidence, namely their reactions with water, with dilute acids and, best of all, displacement reactions.
Option (A) is wrong: the order it gives may look familiar from the reactivity series, but it does not come from these observations. Nothing in the burning test separates zinc, iron, lead and copper from one another.
Option (B) is wrong: not burning is not the same as not reacting. Almost all metals combine with oxygen; the layer seen on some samples is an oxide (copper, for example, gets a black coat of copper(II) oxide).
Option (C) is wrong: brightness of the flame is not a measure of reactivity. Sodium reacts more vigorously than magnesium, so it is the more reactive metal.

The reactivity series: what each metal reacts with, and where hydrogen and carbon sit among them.