Apple remote
Can an Apple Remote make the sound increase on a Sony tv automatically without touching the remote or tv remote
Someone has to press the Volume Up or Volume Down (or Mute) buttons …
If you meant Siri Voice Control, then no. Volume control on the TV is done by IR signals from the remote directly to the TV (Apple TV box is not involved in that).
This is what Siri for Apple TV can do: Use Siri on your Apple TV - Apple Support
If you have HomePod smart speakers, then those can do volume control by voice.