While the macaroni is still hot, sprinkle with apple cider vinegar. Add shredded carrots and grated onion. Toss to combine and let cool for 15 minutes.
In a separate bowl, whisk together mayonnaise, milk, and sugar. Fold the mayo mixture into the cooled macaroni until evenly coated. Add salt and pepper to taste.