Can any lens be used along with an adapter to shoot macro using Canon EOS M100 ? Please guide me regarding this.
Canon sells an EF-M 28mm f/3.5 Macro IS STM lens that would fit directly on your M100, so, yes, macro photography with that body is definitely possible. The 28mm lens would have a very close working distance, though, so if your intended subject is something that might get spooked by the front element of a lens being just a couple mm away from it, you might be better off with one of the other options (e.g. the EF 100mm f/2.8 Macro USM or EF 100mm f/2.8L Macro IS USM) with an appropriate EF/EF-S to EF-M adapter, or as mentioned in another answer, investigating extension tubes, or lens reversal methods (either the two-lens method or an appropriate lens reversal adapter).
Many years ago, I did macro photography with a Kodak Pony 135 -- fixed lens, scale-focus 35mm. I used close-up filter lenses, a calculated distance setting, a small aperture, and a tape measure. Got some nice images of some tiny flowers around 1973. If you want it, you can do macro with darned near any camera.
If your lenses can be changed, you can use extension tubes or reverse mounting rings to fit your filter diameter and camera body. Whether they can or not, you can use close-up filters, and you can, if needed, stack those to get still closer to your subject.