Thank you all for the help.

Firstly I tried the focus stacking : really hard to do while holding camera in hard (at least for me it was)

Tried with a tripod It works very good.

but I wanted to do it though the camera as sometimes it may not be possible to take multiple shots.

so tried with F number starting from F16 onwards.

It works perfectly in bright sunlight but indoors...not so much.

so I have bought a YongNuo MR-58 Ring flash (bargain for $45 compared to Canon's offering)

given below are a few sots I took Outdoors. Again Thanks a lot for the help guys. Really appreciate it.