Yes. In informal spoken language we often omit parts of the sentence. The full sentence would be 'Are you any good at playing the piano?" I would say all native speakers will understand and say phrases like 'Any good at (something)? " - but be careful using this in formal situations or with non-native speakers.