Thanks for everyone's further contributions! I think we're all in agreement that there is a L/N or L/E wiring fault of some description, which needs looked into before we can turn that circuit on again.
I should have mentioned in my last post but I didn't because a fault is a fault and I didn't want to confuse the thread until a solution was found, but we discovered this week that the RCD no longer works. In April when the lights were originally installed, the RCD (30mA covering whole house) was tested and functioned correctly. Last week when the electrician visited he checked the RCD as a tick box exercise at the end of his visit and could not get it to trip either by the usual testing method of tripping a socket or by physically pressing the test button on the RCD itself.
Given the fault condition this means there could realistically be a live/earth fault somewhere, all the more reason to keep the circuit switched off until properly tested. In the guy's defence, remember that when he left he thought he had fixed the original issue of a tripping MCB (and arguably he has), so he didn't recommend any action further than replacing the RCD. It seems obvious though that with an unexpected high current situation and a failed RCD, that he should have done further investigation.
I have a different electrician coming tomorrow, wish me luck. I am also getting quotes for the RCD to be fixed as well as potentially replacing the CU with a more up-to-date RCBO version, but I will need this fault fixed before I do the CU.