For VM scale set - yes, as you associate the scale set resource as the backend pool so this will get updated automatically as you scale out.
For availability sets, no this is for VM resiliency and as you must associate each individual VM nic with the Azure load balancer it will not automatically add new VM nics to the backend pool so this is manual.