Solved! (I think at least)!
Thank you all for your help especially Drumtochty I seem to have got to the bottom of this. I set about testing other things that could have been wrong with the car (ECU, CAS etc), neither seemed to be the problem. Turns out that I had bought a cheap coil pack from ebay which failed. It could have been something to do with poor spark plugs, HT leads or earth straps which I changed a few weeks ago, none seemed to be bad but I changed them anyway to make sure. You are probably all more knowledgeable than me but from what I understand if any of these parts had been weak then the coil pack would have been under too much resistance, the chips internally got hot and failed.
Interestingly enough I googled the part number of the coil pack and the below link came up on a bulk-buy website, Chinese manufactured and likely to be very poor quality at between $20 and $28 so beware of buying cheap coil packs of ebay as this is probably where they come from.
https://www.alibaba.com/product-detail/Ignition-Coil-for-MAZDA-MX5-NB_685129479.html
I have written a brief fault finding below for anyone else experiencing ignition problems:
Coil pack test - swap over connector to coil pack from ECU together with HT leads. If one pair of cylinders didn’t fire and now the other pair don’t then it is likely that the coil pack that has failed
OBD - check any faults from this, it’s located on the passenger side, you can either make a tester up from an LED, resistors and wires or buy one
CAS (cam angle sensor, next to coil pack) - can cause misfire if not reading properly, if the coil packs are working correctly after doing the test above then this could be a cause. The CAS takes a reading from 1&4 and 2&3 separately so if one bank of cylinders isn’t firing correctly then it could be this, read Drumtochty’s note on this forum: https://www.mx5oc.co.uk/forum/yaf_postst114571_Mk1-Non-start-1-6-baffled.aspx
ECU - This is located in the passenger footwell, check that this isn’t sitting in water or damp, this is could also be another cause of misfire
Earth straps - the main one from the engine on a 1.8 is on the passenger side, check this isn’t corroded, an easy replacement anyway especially as the car is over 20 years old. There are also other earths running from parts of the ignition to the engine, I can help find these if anyone needs a hand
HT leads - swap with replacements each one, pull out and test if cylinder stops firing
Spark plugs - check gap, if more than 1.3mm then replace, can cause the coil pack to fail as creating extra resistance
If anyone needs a hand I’m happy to share more of my own experience to help figure it out