Simple module that let you configure weights for your profile categories so you can change the order of them in the User Registration Form.
Drupal 6 version also changes the order of the tabs in the user edit form thanks to the hook_menu_alter() function.
Drupal 5 Notes:
It does not change the order of the tabs in the user edit form. Please readfor further discussion about this.