node load multiple order by
No, results of node_load_multiple() are in the order in which the node IDs were passed to it in the first place. There are no other sorting options through that function.

The weight module doesn't appear to have an API for this, so you'll need to create a query that joins the node and weight_weights tables to get the nids in the right order, then pass them to node_load_multiple().