Currently there are 4 native Macro Prime lenses for Sony A6500 and all of these lenses are autofocus (AF) type.
A6500 also has a sensor based image stabilization system which means that all of these lenses will be stabilized when used on A6500.
Since Sony A6500 has environmental sealings (Weather Sealing), you may like to couple your camera with one of these 3 Macro Prime lenses with Weather Sealings.