"You’ve probably inadvertently connected lighting L-E or something similar"
Definitely not. I've checked this. On some of the SWA the earth is Grey and on other the earth is the usual yellow/green, so I'm 100% sure I didn't connect the wrong wires. Besides, the 2 new light fittings I originally added, which seemed to start this issue, have been removed. Even after removing some of the other circuits e.g. unplugging the festoon lights (C6) and/or disconnecting the wall lights (C5), the remaining lights will work but will eventually cause a trip, either after a length of time, or when a light etc. connected to the same RCD is turned on. I say "after a length of time", but it is possible someone switched something on!