Yes it is possible - but not the way you make it sound so simple! It take quite a bit of money to invest in the correct equipment and support team to go hunting for coins and small wrecks.

However if you go to the usual touristic dive site you can find lots of dive 'treasure'. I have found bottles of beer. Dive masks and so on !