An important thing about RCDs, and the reason they are so useful, is that they trip far faster and on much lower current than an MCB. Take a 5 amp MCB, it will only trip if there is an overload above 5 amps. 5 amps applied in the right place can kill you. They protect the wiring from overload (and in turn overheating) and any appliances that are plugged in. They don't do a good job with humans.
An RCD, as others have said, sense an imbalance between + and - current and trip really quickly. That 5 amps going through a human which wouldn't trip an MCB will trip an RCD because some, a very few milliamps, is going to earth. Possibly through you. You need both, to protect against both situations. When RCDs first became 'mainstream' in domestic situations - early 1970's perhaps - they were called ELCBs, earth leakage circuit breakers which in many ways is a better name because it explains itself.
Some things to think about - from a layman's perspectve, I'm not qualified:
As its a physical action, might there be a loose wire in the socket which momentarily touches the backbox when you wiggle the switch? Nothing to do with the lights. Try turning it on an off a few times with nothing plugged in.
Silly things can trip an RCD - damp, self-immolating spiders, mice chewing the nice tasty insulation, the momemtary arc tracking to earth, is it all nice and dry and clean in the area?
Then get something dead simple, desk lamp say, plug that in and see if it trips at all.
Then put your lights in a different socket, see what happens. Do you have one RCD protecting the whole house? If its a split load fuse box try the lights in a circuit protected by a different RCD.
But quite likely its the lights, some odd bit of circuitry - once upon a time they had mains voltage and just went on and off, now they have complicated stuff inside and do all sorts. Assuming its only happens with those lights, and on the grounds that new lights cost a lot less than any of the alternatives, perhaps the bin beckons? Perhaps the bin beckons before you risk fiddling with anything.
OR, get an electrician in? ("Tricky chap, electricity" - to misquote some ancient BBC TV comedy)