If you want to buy Lightroom (essentially a lifetime user license) it's $149.
By looking at the Adobe site, I don't see Photoshop CS6 offered for sale, but you can join the 'Creative Cloud' and always have the latest version for $20/month.
You can still find Photoshop CS6 in stores, basic version is $639. Photoshop Extended is $999 (don't ask me the difference).
Of course, anyone thinking of getting the software should ask themselves if they really need Photoshop. It's a very large, comprehensive program that will do more than any one person will need. Most photographers would be happy with the 'lite' version, Photoshop Elements. Photoshop Elements isn't available on the cloud, and is available for purchase for $99.
And to be clear, you don't NEED both Lightroom and Photoshop (either full or Elements). Photoshop (along with Adobe Bridge) will do practically everything that you can do in LR. LR just streamlines it and makes it much easier and faster. And there are many, many things that you can do with Photoshop, that you can't do with LR.
But that being said, Lightroom will do 90% of what 80% of photographers need to do on a daily basis.