It will be hit and miss at to whether or not individual stores carry it in stock.
In-store collection is available for most Tesco Direct products though. It's usually only bulky items that can't be collected from a store and have to be delivered to your home.
You just order on the website and select collection when going through the checkout.