I will have to agree with "xor" comments, you should do the count formula first,

=COUNTIF($B$2:$B$100,B2)

I added this formula in column D

then use the sort options as shown below found on the HOME ribbon on the top right, sort by ID add a level and sort by No. of Child