I think I am correct, that those Wylex MCB's, only isolate the live, in which case, if the RCD trips, only when that MCB is turned on, irrespective of whether the light switch for the circuit is on, or off - that suggest to me, there is leakage between L and E, before the switch.
For the OP - As a final check, if you locate and isolate the L, which feeds to switch for the six lights, safely isolate it with a connector, switch back on and the RCD still trips - It suggests the fault is on the cable between the consumer unit, and the switch.
If the cable goes up, to the ceiling, before making it's way across to the switch, then the chances are, that a floor nail or similar has damaged the cable.