Hi Jamal,
Zoom To Selected is short for Zoom to Selected Features. Using your screenshot in the original post, what would you have us do if you selected value = 2? There are 25551 pixels. Where do you want us to zoom? The rows in a raster attribute table are not like rows of discrete features in a feature class, nor is there a shape field containing geometry for easy query. It's not like there is a property within a raster dataset that stores the minimum bounding geometry for each value in the raster that could be used as a zoom extent.
The case where the count is 1 is the only time you have a discrete record in a raster attribute table. I would argue its quite uncommon from all the data I've seen over the years. Zooming to selected pixels would have to make sense for all cases to even be considered.
There are multiple ways to 'find' this pixel.
1. As stated earlier, convert to features.
2. Create a new raster with just that one pixel. There are several ways to do this one. Raster calculator, conditional statements, or if you want to make it easy just use Extract by Attribute from spatial analyst.
Best,
Eric